package com.sctlqq.wuye.mapper;

import com.sctlqq.wuye.entity.Integral;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sctlqq.wuye.entity.IntegralDto;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 15811
* @description 针对表【itegral】的数据库操作Mapper
* @createDate 2022-04-16 21:03:28
* @Entity com.sctlqq.wuye.entity.Itegral
*/
public interface IntegralMapper extends BaseMapper<Integral> {

    @Select("select integral.id,name,img,price,time " +
            "from integral,goods " +
            "where integral.gid=goods.id " +
            "and integral.uid = #{uid} " +
            "order by time desc ")
    List<IntegralDto> getIntegralDetailList(Long uid);
}




